{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":339,"n_cols":28,"rows_kept":339,"merged":[[0,0,0,4],[0,8,1,8],[20,8,21,8],[22,0,22,4],[31,8,32,8],[32,0,32,4],[45,8,46,8],[46,0,46,4],[60,0,60,4],[60,8,61,8],[74,8,75,8],[75,0,75,4],[84,5,85,7],[87,8,88,8],[88,0,88,4],[98,8,99,8],[99,0,99,4],[110,8,111,8],[111,0,111,4],[127,8,128,8],[128,0,128,4],[140,8,141,8],[141,0,141,4],[155,0,155,4],[155,8,156,8],[165,0,165,4],[166,8,167,8],[172,8,173,8],[173,0,173,4],[185,8,186,8],[186,0,186,4],[195,8,196,8],[196,0,196,4],[218,8,219,8],[219,0,219,4],[231,8,232,8],[232,0,232,4],[248,8,249,8],[249,0,249,4],[258,8,259,8],[259,0,259,4],[266,0,266,4],[266,8,267,8],[274,8,275,8],[276,0,276,4],[286,0,286,4],[287,8,288,8],[297,0,297,4],[299,8,300,8],[314,8,315,8],[316,0,316,4],[331,8,332,8],[332,0,332,4]]}
["Import Chart Of Account Format",{"$nulls":7},1]
[]
["Number","Code","LocalName","EnglishName","Type","AccountType","ParentNumber"]
[null,null,"acc1","acc1","Sub","Income"]
[null,null,"acc2","acc2","Main","Expense"]
[{"$nulls":5},"FixedAssest"]
[{"$nulls":5},"Bank"]
[{"$nulls":5},"Loan"]
[{"$nulls":5},"CreditCard"]
[{"$nulls":5},"Equity"]
[{"$nulls":5},"AccountsReceivable"]
[{"$nulls":5},"OtherCurrentAssest"]
[{"$nulls":5},"OtherAssest"]
[{"$nulls":5},"AccountsPayable"]
[{"$nulls":5},"OtherCurrentLiability"]
[{"$nulls":5},"LongTermLiability"]
[{"$nulls":5},"CostofGoodsSold"]
[{"$nulls":5},"OtherIncome"]
[{"$nulls":5},"OtherExpense"]
[]
[{"$nulls":8},2]
[]
["Import Cost Center Format"]
[]
["Code","LocalName","EnglishName","StartDate","EndDate","Type","manager","Note","Approximate cost","site supervisor","City","Zone","Size","Reference","District","plot","Additional Amount","Actual Delivery Date"]
[1,"c1","c1","01.01.2018","01.01.2020","Sub","manager","Note",123.4,"site supervisor ","City ","Zone","Size","Reference","District","plot",123.4,"2024-01-01"]
[2,"c2","c2","01.01.2019","01.01.2021","Main","manager","Note",567.8,"site supervisor ","City ","Zone","Size","Reference","District","plot",567.8,"2024-02-02"]
[]
[]
[]
[]
[{"$nulls":8},3]
["Import Customer / supplier Format"]
[]
["Code","LocalName","EnglishName","DateOfBirth","TaxNumber","LandPhone","CellPhone","Fax","Email","NationalityCode","PostCode","CreditDays","CreditLimit","Note","HomeAdrees","WorkAdrees","WebSite"]
[1,"cust8","cust8","1981-03-13",12,213456,843565591,2134568,"info@erpbrilliant.com",1]
[2,"cust9","cust9","1981-03-14",12,213456,843565591,2134568,"info@erpbrilliant.com",1]
{"$rows_empty":8}
[{"$nulls":8},4]
["Import Items Format"]
[]
[]
["Number","Code","LocalName","EnglishName","GroupCode","ClassNumber","UnitNumber","UnitBarCode","FirstBalance","TotalPrice","PurchaseDate","SalePrice","CostPrice","Note","TaxKind","SupplierCode","NoSaleZeroBalance"]
[9090,9090,"pro 90","pro 90",2,1,1,10003,10,150,"09.01.2016",15,10.5,"note1","Taxable",null,true]
[9091,9091,"pro 91","pro 91",2,1,1,10004,5,20,"07.03.2016",25,12.3,"note2","NonTaxable",null,false]
{"$rows_empty":8}
["Import JV (Entry Voucher) Format",{"$nulls":7},5]
[]
[]
["voucherCode","BookNumber","SpecialNumber","Document","VoucherDate","Credit","Debit","AccountCode","Account Name","CustomerCode","SupplierCode","Note","RowNote","Reference","CostCenterCode"]
[4,"A",null,null,"2018-04-28",{"v":100000,"d":"100,000.00"},0,20208,{"$nulls":4},"سحب نقدي","Cash withdrawal ","1008"]
[4,"A",null,null,"2018-04-28",0,{"v":100000,"d":"100,000.00"},20208,{"$nulls":4},"سحب نقدي","Cash withdrawal ","1008"]
[5,"A",null,null,"2018-05-01",{"v":3280,"d":"3,280.00"},0,20103,{"$nulls":4},"البنك / حساب اعمار","Bank / Account Emaar","1008"]
[5,"A",null,null,"2018-05-01",0,{"v":3280,"d":"3,280.00"},10101,{"$nulls":4},"البنك / حساب اعمار","Bank / Account Emaar","1008"]
[]
[]
[]
[]
[]
[]
[{"$nulls":8},6]
["Import invoice,Orders and item transfter ( CTRL + I )"]
[]
["Code","Quantity","ItemPrice"]
[103,1,11]
[104,2,22]
[]
[]
[]
[]
[{"$nulls":5},"Real Estate Version only"]
[]
[]
[{"$nulls":8},7]
["Import lease units "]
[]
[]
["Code","LocalName","EnglishName","UnitType","Parent","Note","PeopleAllowed","WaterMeterCode","ElectricityMeterCode"]
[null,"flat4","flat4",1,2]
[null,"flat5","flat5",2,3]
[null,"flat6","flat6",3,2]
[null,"flat7","flat7",4,3]
[]
[]
[{"$nulls":8},8]
["Import lease Contacts"]
[]
[]
["RentalKind","StartDate","EndDate","RentalValue","Insurance","UnitCode","TenantCode","Note","Code","ContractDate","ManagementRevenueValue","OtherFee"]
["Daily","2017-01-01","2018-12-28",5000,10,1,10,"unit1"]
["Weekly","2017-01-02","2018-12-29",6000,20,2,11,"unit2"]
["Monthly","2017-01-03","2018-12-30",7000,30,3,13,"unit3"]
["HalfYearly","2017-01-04","2018-12-31",8000,40,1,2]
["Yearly","2017-01-05","2018-12-28",9000,50,2,6]
[]
[]
[{"$nulls":8},9]
["Import Invoice"]
[]
[]
["invoiceCode","BookNumber","SpecialNumber","Document","InvoiceDate","InvoiceType","clientCode","clientName","Note","ItemCode","ItemPrice","ItemQuantity","Discount","StoreCode","CostCenterCode","UnitCode","TaxCode","PercentageTax","TaxAmount","RowNote","Reference","ItemExpiryDateIn","AccountCode"]
["y01",null,"a",null,"11.03.2019","Cash",null,"client 1","n1","1",1,2,null,2,null,1,2,10,null,"rr1"]
["x01",null,"a",null,"11.03.2019",{"$nulls":4},"10",2,3,null,2,null,1,2,5,null,"not1"]
["x01",{"$nulls":3},"11.03.2019",{"$nulls":4},"100",3,4,0.25,2,null,1]
[]
["x02",null,"b",null,"11.03.2019","Credit",380,null,"n1","101",4,3,0.3,2,null,1,2,10,null,"rr1"]
["x02",{"$nulls":3},"11.03.2019",{"$nulls":4},"102",5,5,null,2,null,1,{"$nulls":3},"not1"]
["x02",{"$nulls":3},"11.03.2019",{"$nulls":4},"103",6,7,null,2,null,1,2,5,null,"not3"]
[]
[]
[]
[]
[]
[{"$nulls":8},10]
["Import Fixed Assets"]
[]
["Code","LocalName","EnglishName","PurchaseDate","PurchaseAmount","LastDepreciationDate","PreviousdepreciatedAmount","DepreciationAnnualPercentage","DepreciationMethod","AccountCreditCode","AccountDebitCode","AccountAssetCode","ParentCode","Note"]
[9090,"pro 90","pro 90","2018-02-01",1000,"2019-05-02",200,10,"DecliningBalance",10101,10102,10103,1,"note1"]
[9091,"pro 91","pro 91","2018-05-02",500,"2019-05-02",50,20,"StraightLineBasis",10101,10102,10103,1,"note2"]
{"$rows_empty":7}
[{"$nulls":8},11]
["Import Orders ( LPO - Quotations )"]
[]
["OrderCode","BookNumber","SpecialNumber","Document","OrderDate","clientCode","clientName","Note","ItemCode","ItemPrice","ItemQuantity","Discount","StoreCode","CostCenterCode","UnitCode","TaxCode","PercentageTax","TaxAmount","RowNote"]
["y01",null,"a",null,"11.03.2019",null,"client 1","n1","1",1,2,null,2,null,1,2,10,null,"rr1"]
["x01",null,"a",null,"11.03.2019",{"$nulls":3},"10",2,3,null,2,null,1,2,5,null,"not1"]
["x01",{"$nulls":3},"11.03.2019",{"$nulls":3},"100",3,4,0.25,2,null,1]
[]
["x02",null,"b",null,"11.03.2019",380,null,"n1","101",4,3,0.3,2,null,1,2,10,null,"rr1"]
["x02",{"$nulls":3},"11.03.2019",{"$nulls":3},"102",5,5,null,2,null,1,{"$nulls":3},"not1"]
["x02",{"$nulls":3},"11.03.2019",{"$nulls":3},"103",6,7,null,2,null,1,2,5,null,"not3"]
[]
[]
[]
[]
["Import Employee",{"$nulls":7},12]
[]
[]
["Code","LocalName","EnglishName","EmployeeID","DepartmentCode","Gender","DateOfBirth","MaritalStatus","ProfessionCode","NationalityCode","JoiningDate","CellPhone","LandPhone","Email","WorkAdrees","HomeAdrees","BankAccountNumber","IBAN"]
[12,"emp12",null,12,1,"Male","1981-03-13","Single",2,1,"2020-04-13",843535591,214579,"nn@gmail.com","addres work","home",123456,5478]
[13,"emp13",null,13,1,"Female","1990-02-25","Married",3,null,"2020-04-14",843535591,214579,"m@gmail.com","add2","home2",3242,23423]
[{"$nulls":7},"Divorced"]
[{"$nulls":7},"Widow"]
[]
[]
["Serial Number "]
[{"$nulls":8},13]
["SerialNumber","Note","Reference","ManufacturingDate"]
["t1","n1","r1","2021-01-21"]
["t2","n2","r2","2021-01-22"]
["t3","n3","r3","2021-01-23"]
[]
[{"$nulls":8},14]
["(Payment / Receipt ) Voucher Import"]
[]
["voucherCode","BookNumber","SpecialNumber","Document","VoucherDate","CurrencyCode","BranchCode","BeneficiaryCode","RepCode","Amount","AccountCode","Account Name (Ignore it ) but keep it in excel to chech","CustomerCode","SupplierCode","Note","RowNote","Reference","CostCenterCode","Type","VoucherOrCheque","ChequeAmount","ChequeNumber","ChequeBankCode","ChequeDate","ChequeStatus","ChequePayerName","ChequeNote","LeaseCode"]
[5,"A","a1","a","2022-10-17",{"$nulls":4},500,10101,"Bank no1",null,null,"deposit 1","a",null,null,"PDC",0,{"$nulls":7},18]
[5,"A","a1",null,"2022-10-17",{"$nulls":4},100,10105001,"cash on hand",null,null,"cash depoit","aa",null,null,"PDC",0,{"$nulls":7},18]
[4,"B","a2",null,"2022-10-17",{"$nulls":4},3000,10105001,"managemant salary",null,null,"may salary","aaa","رواتب مايو",null,"PDC",0,{"$nulls":7},18]
[4,"B","a2","c","2022-10-17",{"$nulls":4},200,10105001,"bank no 000",{"$nulls":3},"aaaa",null,null,"PDC",0,{"$nulls":7},18]
[5,{"$nulls":18},1,500,1,1,"2022-10-17",null,"client a","note 1",18]
[5,{"$nulls":18},1,100,2,1,"2022-10-17",null,"client a","note 2"]
[4,{"$nulls":18},1,3000,3,1,"2022-10-17",null,"client a","note 3"]
[4,{"$nulls":18},1,200,4,1,"2022-10-17",null,"client a","note 4"]
[{"$nulls":18},"Cash"]
[{"$nulls":8},15,{"$nulls":9},"Cheque"]
["Items Unit Import"]
[]
[]
["ItemCode","UnitNumber","ConversionRate","BarCode","SalePrice","PurchasePrice"]
[100001,2,5,"pro 90",2,1]
[100002,3,4,"pro 91",2,1]
[]
[]
[]
[{"$nulls":8},16]
["Import manufacture's item raw material"]
[]
[]
["ParentItemCode","ItemCode","UnitNumber","Quantity","ItemPrice","PricePolicy","StageCode","ItemColorCode","ItemSizeCode","StoreCode"]
[39011411781,39010511762,1,2,6,"None"]
[39012024430,39010511763,1,3,6,"Amount"]
[39012024431,39010511764,1,4,6,"SalePrice"]
[39011411781,39010511764,1,5,6,"SpecialPrice"]
[39011411781,39010511764,1,6,6,"WholesalePrice"]
[39011411781,39010511764,1,7,6,"WholesalePriceHalf"]
[39011411781,39010511764,1,8,14,"PurchasePrice"]
[39011411781,39010511764,1,9,14,"CostPrice"]
[39011411781,"39012221635",1,10,8,"Average"]
[39011411781,"39012221635",1,11,6,"LastEntryPrice"]
[39011411781,"39012221635",1,12,24,"Manufacturing"]
[39011411781,"39012221635",1,13,12,"ItemCard"]
[39012024430,"39012221635",1,14,12]
[39012024430,"39012221635",1,15,6]
[]
[]
[]
[]
[{"$nulls":8},17]
["Employee Salary Elements"]
[]
[]
["Code","Element Date","Employee Code","Branch","Note","Element Code","Element Kind","Amount","Row Note"]
[11,"2024-03-09",212,null,"n1",2,"Allowance",100,"r n 1"]
[22,"2024-03-09",211,null,"n2",1,"Deduction",200,"r n 2"]
[]
[]
[]
[]
[]
[]
[{"$nulls":8},18]
["Documents Import"]
[]
["Customer Code","Supplier Code","Employee Code","Document Parent Code","Document Type Code","Issue Place","Local Name","English Name","Issue Date","Expiry Date","Document Code","Cost Center Code","Note"]
[null,null,1,null,1,null,"Visa","Visa",{"$f":"DATE(YEAR(J236)-1, MONTH(J236), DAY(J236))","v":"2024-03-22"},"2025-03-22",3]
[null,null,2,null,1,null,"Visa","Visa","2024-09-03","2025-09-03",4]
[null,null,3,null,1,null,"Visa","Visa","2024-11-09","2025-11-09",5]
[null,null,4,null,1,null,"Visa","Visa","2024-03-29","2025-03-29",6]
[null,null,5,null,1,null,"Visa","Visa","2023-01-30","2024-01-30",7]
[null,null,6,null,1,null,"Visa","Visa","2024-04-02","2025-04-02",8]
[null,null,7,null,1,null,"Visa","Visa","2024-09-06","2025-09-06",9]
[]
[]
[]
[]
[]
[]
[{"$nulls":8},19]
["Cheque Collection Import"]
[]
["CellPhone","Cheque Date","Cheque Amount","amount paid","special number","branch","book","document","Debit account code","Credit account code"]
[1,"2024-02-18",{"v":100,"d":"100.00"},{"v":5,"d":"5.00"},1,{"$nulls":3},10101,10105]
[74242083,"2024-02-18",{"v":200,"d":"200.00"},{"v":7,"d":"7.00"},2,{"$nulls":3},10101,10105]
[]
[]
[]
[]
[{"$nulls":8},20]
["Item List Update Price"]
[]
["BarCode","SalePrice","PurchasePrice",null,"in case of Null will not update"]
[123,0]
[456,10.8,15]
[]
[]
["Account Reconciliation Allocation",{"$nulls":7},21]
[]
["Date","Debit","Credit"]
["2024-03-06",10]
["2024-03-06",0,10]
["2024-03-07",20,0]
["2024-03-07",0,30]
[]
[{"$nulls":8},22]
[]
["Import Item Prices"]
[]
["Code","SalePrice","CostPrice","PurchasePrice","SpecialPrice","WholesalePrice","WholesalePriceHalf","ExportPrice","CommissionPrice","ManufacturingPrice","IsPricePercentage","PricePercentage"]
[3810016778,1,2,3,4,5,6,7,8,9,false,10]
[3810016779,20,19,18,17,16,15,14,13,12,true,11]
[]
[]
[]
[]
[]
["Import Client / Supplier Special Prices"]
[{"$nulls":8},23]
["Code","Sale Price","Purchase Price"]
["DED-EST-INF",null,22.33]
["IMM-REN-EST-DXB-3.55",33.44]
["MOL-UPD-EST"]
["IMM-NEW-WOR-ENT-PER-OUT-DXB-NO-BC",88.99,99.44]
["gjkdbhxkj fhu fahjkl",54,465]
[]
[]
[]
["Import Employee Attendance"]
[]
[{"$nulls":8},24]
["Employee Number","Attendance DateTime"]
[5,"2024-06-21T15:00:46"]
[5,"2024-06-12T22:08:46"]
[5,"2024-06-21T15:00:46"]
[5,"2024-06-12T22:08:46"]
[5,"2024-06-21T15:00:46"]
[5,"2024-06-12T22:08:46"]
[5,"2024-06-21T15:00:46"]
[5,"2024-06-12T22:08:46"]
[5,"2024-06-21T15:00:46"]
[5,"2024-06-12T22:08:46"]
[5,"2024-06-21T15:00:46"]
[5,"2024-06-12T22:08:46"]
[]
[{"$nulls":8},25]
[]
["Import OnceOff Allowance & Deduction"]
[]
["Code","Date","EffectiveDate","BranchCode","EmployeeCode","OnceOffElementCode","OnceOffEquoationCode","Quantity","Amount","Note","CostCenterCode","ProjectCode"]
[119,"2021-03-14",null,1,103,1,5,1,null,"nnnn1 ",1001," "]
[120,"2022-07-22",null,null,104,2,null,2,22,"nn2",null,1]
[120,"2022-08-23","2022-07-22",4,109,3,null,3,null,"nnnn3"]
[121,"2022-06-22","2024-07-22",null,103,4,5,4,44]
[121,"2022-07-20","2022-07-22",1,104,5,null,5,55,"nnnnnn5",1002,2]
[121,"2023-07-22","2024-01-22",null,109,6,null,6,66]
[122,"2025-07-22","2022-07-22",5,103,7,3,7,null,"nnnnnn7"]
[122,"2024-07-22","2022-07-22",null,104,8,null,8,88,null,1003]
[122,"2024-01-22","2024-07-22",4,109,9,null,9,99,"nnnnn9",null,3]
[]
[]
[]
[{"$nulls":8},26]
["Import Stock Transfer"]
[]
["Code","Date","SpecialNumber","BookNumber","Document","Note","FromStore","ToStore","ItemCode","Quantity","Price","UnitCode","UnitBarcode","RowNote","Reference","Branch"]
[1826,"2025-05-09","s1","b1","D1","n1",7,13,3810016778,2,"hjg",null,1110000625420,"rn1","r1",1]
[1826,"2025-05-09","s2","b2","D2","n2",7,14,3810016779,3,null,null,1110000625437,"rn2","r2"]
[1826,"2025-05-09","s3","b3","D3","n3",7,15,3810016780,4,null,1,null,"rn3","r3",4]
[1826,"2025-05-09","s4","b4","d$","n4",7,16,3810016781,5,null,2,1110000625451,"rn4","r4",5]

{"sheet":"Sheet2","index":1,"n_rows":8,"n_cols":21,"rows_kept":8,"merged":[[0,0,0,4],[0,13,1,13]]}
["Import invoice",{"$nulls":12},5]
[]
[]
["invoiceCode","BookNumber","SpecialNumber","Document","invoiceDate","due date","type","client name","client acc no","item code","item qty","item price","discount amout","item unit","tax code","tex amount","store code","Note","RowNote","Reference","CostCenterCode"]
[4,"A",null,null,"2018-04-28",null,"cash",null,null,{"v":111,"d":"111.00"},{"v":10,"d":"10.00"},20208,{"$nulls":6},"سحب نقدي","Cash withdrawal ","1008"]
[4,"A",null,null,"2018-04-28",null,"credit",null,null,{"v":112,"d":"112.00"},{"v":20,"d":"20.00"},20208,{"$nulls":6},"سحب نقدي","Cash withdrawal ","1008"]
[5,"A",null,null,"2018-05-01",null,"withoutvoucher",null,null,{"v":1113,"d":"1,113.00"},{"v":30,"d":"30.00"},20103,{"$nulls":6},"البنك / حساب اعمار","Bank / Account Emaar","1008"]
[5,"A",null,null,"2018-05-01",{"$nulls":4},0,{"v":3280,"d":"3,280.00"},10101,{"$nulls":6},"البنك / حساب اعمار","Bank / Account Emaar","1008"]